View is the ANSI definition of a virtual table. A view is synonymous to a stored query in Access that is comprised of a SELECT statement without parameters. A view is a stored definition that is materialized at execution. It is different from a table in that it does not physically store any data. It returns data only.
A view can be created from the new ANSI SQL CREATE VIEW syntax exposed through the Microsoft� OLE DB Provider for Jet. Alternatively, a procedure can be created to allow for SQL DML statements and SELECT statements that have parameters. This can be done with the new CREATE PROCEDURE syntax exposed through the Microsoft OLE DB Provider for Jet.